clear
set more off

local path0="C:\Dropbox\GeneticsProject (1)\REStat\round_accepted_replication_files\"

*~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

insheet using "`path0'Data\LevelOfTfp\HallJones.csv", names clear

label var hjy2l "Hall-Jones (QJE'99) LOG output to labor ratio relative to the USA"
label var hjk2y "Hall-Jones (QJE'99) LOG capital to output ratio relative to the USA"
label var hjh2l "Hall-Jones (QJE'99) LOG human capital to labor ratio relative to the USA"
label var hjtfp "Hall-Jones (QJE'99) LOG measure of TFP in the economy relative to the USA"

replace hjy2l = log(hjy2l) 
replace hjk2y = log(hjk2y) 
replace hjh2l = log(hjh2l) 
replace hjtfp = log(hjtfp ) 

egen tt=fill(1(1)10)

* drop duplciates
drop if tt==12 & countrycode=="CSK"
drop if tt==53 & countrycode=="OMN"
drop if tt==67 & countrycode=="DOM"

drop tt

compress
save "`path0'Workfiles\HallJones.dta", replace

